------------------------------------------------------
--created:Son nguyen van
--created_date:23/05/2013
--desc: view category product full
create view v_article
as
	select a.article_id,a.images,a.article_status,
		   a.created,a.modifyed,a.created_by,
		   a.modifyed_by,a.url,
		   b.article_item_id,b.title,b.alias,
		   b.intro_text,b.full_text,b.meta_key,
		   b.meta_desc,b.tag,b.related,
		   b.article_item_enable,b.language_id,
		   c.category_id,
		   d.category_param	
	from tbl_article a 
		 inner join tbl_article_item b on a.article_id = b.article_id
		 left outer join tbl_article_ref_category c on a.article_id = c.article_id
		 left outer join tbl_article_category d on c.category_id = d.category_id
go

